Daily Schedule for 444

Note that this schedule might be altered during the quarter. Please make sure to check it every week.

Key:

 

Week of

Monday

Wednesday

Friday

January 1

 

Introduction and Overview

Read: Ch. 1.1,1.2 & 1.3(optional)



January 8

SQL

Read:

3.1,3.5.1-3.5.3

4.1,4.5 - 4.8

 

SQL

Project details discussed

Read:

5, except 5.10

 Project groups decided

 (E-mail Yana)

January 15

 

SQL

Homework1 Due

Read:

7, except 7.2,7.4

Building SQL Applications

Project Description

January 22

SQL

Read:

2 except 2.1 and ODL discussions

 

Database Schema Design 

Programming Assignment Due

Read:

3.1-3.6

 

 

January 29

Database Schema Design

Read:

3.5, 3.6, 3.7 and 6.1, 6.2

Transactions

Read: 7.4

 

February 5

MidTerm

 

Transactions

Project Proposal Milestone 2 Due

Read (vol 2): 7.2, 9.1-9.3, 9.4.1,9.4.2,9.5,9.6.3, 10.3.1, 10.3.2

 

February 12

Transactions

Read: Chapter 8

Storage and Indexes

Homework2 Due

Read (vol 2): Section 3.1.3, 3.2, 3.3.1, 3.3.2, 3.4, 3.5
Section 4.1, 4.2

 

February 19

 

Storage and Indexes

Section 4.3, 4.4 and 5.4

Homework3 Due

 

February 26

Query Processing

Read (vol 2): Section5.4.1-5.4.3

Query Processing

Project Report Due

Read (vol 2): Section2.3.3-2.3.5, 6.1-6.7, 6.8, 6.9

 

March 5

Query Optimization

15 extra min: final overview (optional)

Read (vol 2): Section 7.2, 7.4, 7.5, 7.6

Query Optimization, XML

Project due date (Interviews) 5-7 pm

Homework4 Due

Project due date (Interviews) 3-5 pm

March 8th--Thursday

March 12

 

 

FINAL EXAM

(March 15th—THURSDAY)

Low 102

2:30-4:20 pm